package com.power.dao;

import com.power.ov.ResultDataTable;
import com.power.pojo.Defect;
import com.power.pojo.Inspetion;

import java.sql.SQLException;

/**
 * Created with IntelliJ IDEA.
 * User: 李辽
 * Date: 2020/10/09 11:01
 * Description:
 * Version: V1.0
 */
public interface InspeDao {
    ResultDataTable QueryListInspection(int page, int limit) throws SQLException;

    int AddInspetion(Inspetion inspetion) throws SQLException;

    int queryLinaNameByLineId(Inspetion inspetion) throws SQLException;

    String queryUserAcountByInspetionAcount(String inspection_accont) throws SQLException;

    ResultDataTable ShowSelectInspection() throws SQLException;

    ResultDataTable ShowSelectState() throws SQLException;

    ResultDataTable SearchInspection(String task_id, String line_number, int state_id) throws SQLException;

    int EditInspetion(Inspetion inspetion) throws SQLException;

    int ChangeCarrieState(String task_id) throws SQLException;

    String setUserCount(Defect defect) throws SQLException;

    int Edit_CarriedInspe(Defect defect) throws SQLException;
}
